Re: concurrent cursors possible with portals?
От | M. Bastin |
---|---|
Тема | Re: concurrent cursors possible with portals? |
Дата | |
Msg-id | a0610051bbd09f712f42c@[213.224.114.176] обсуждение исходный текст |
Ответ на | function accessing other db ("Marcus Andree S. Magalhaes" <marcus.magalhaes@vlinfo.com.br>) |
Список | pgsql-novice |
>"M. Bastin" <marcbastin@mindspring.com> writes: >> I'm reading the docs about the extended query language and the >> portals. Is it possible to use portals as a kind of concurrent >> cursors over a single TCP/IP connection? >> Or should you execute and close portals one after another and never >> execute the next portal before the previous one is closed? (Like >> regular transactions.) > >You can certainly have multiple portals open and fetch from different >ones in turn; not clear if that's what you meant. Yes, I was thinking about a threaded client that would be able to fetch from several portals (quasi) simultaneously and repeatedly (but with other parameters) over 1 TCP/IP connection. The only thing that bothers me is the Sync command that would put an end to all portals at once isn't it? The docs seem to say you need to issue a sync after each cycle. There doesn't seem to be a possibility to selectively keep some portals open this way. That's what I make from reading the docs, I haven't had the chance to actually experiment with it yet. (I'm in the process of implementing the frontend-backend protocol v3 for my IDE. Only after that can I start experimenting.) Marc
В списке pgsql-novice по дате отправления: